Pandas Profiling Report

Dataset statistics

Number of variables	13
Number of observations	9994
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	2448
Duplicate rows (%)	24.5%
Total size in memory	674.9 KiB
Average record size in memory	69.1 B

Variable types

Numeric	8
Categorical	5

Alerts

Dataset has 2448 (24.5%) duplicate rows	Duplicates
`Order Date` is highly overall correlated with `Ship Date`	High correlation
`Ship Date` is highly overall correlated with `Order Date`	High correlation
`Sales` is highly overall correlated with `Profit`	High correlation
`Discount` is highly overall correlated with `Profit`	High correlation
`Profit` is highly overall correlated with `Sales` and 1 other fields	High correlation
`Product ID_id` is highly overall correlated with `Category` and 1 other fields	High correlation
`Category` is highly overall correlated with `Product ID_id` and 1 other fields	High correlation
`Sub-Category` is highly overall correlated with `Product ID_id` and 1 other fields	High correlation
`Discount` has 4798 (48.0%) zeros	Zeros

Reproduction

Analysis started	2023-04-11 17:37:04.553201
Analysis finished	2023-04-11 17:37:14.365236
Duration	9.81 seconds
Software version	ydata-profiling vv4.1.2
Download configuration	config.json

Order Date
Real number (ℝ)

Distinct	1237
Distinct (%)	12.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	14619.748

Minimum	13887.072
Maximum	15145.92
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	78.2 KiB

Quantile statistics

Minimum	13887.072
5-th percentile	14006.866
Q1	14323.392
median	14668.992
Q3	14947.2
95-th percentile	15117.408
Maximum	15145.92
Range	1258.848
Interquartile range (IQR)	623.808

Descriptive statistics

Standard deviation	363.30282
Coefficient of variation (CV)	0.024850142
Kurtosis	-1.1532496
Mean	14619.748
Median Absolute Deviation (MAD)	304.992
Skewness	-0.26783343
Sum	1.4610976 × 10⁸
Variance	131988.94
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
14730.336	38	0.4%
15043.104	36	0.4%
14787.36	35	0.4%
15120.864	34	0.3%
15121.728	34	0.3%
15127.776	33	0.3%
15104.448	30	0.3%
15126.912	30	0.3%
15049.152	29	0.3%
14814.144	28	0.3%
Other values (1227)	9667	96.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
13887.072	1	< 0.1%
13887.936	3	< 0.1%
13888.8	1	< 0.1%
13889.664	9	0.1%
13890.528	2	< 0.1%
13892.256	2	< 0.1%
13893.12	2	< 0.1%
13893.984	1	< 0.1%
13895.712	11	0.1%
13896.576	1	< 0.1%

Value	Count	Frequency (%)
15145.92	7	0.1%
15145.056	12	0.1%
15144.192	19	0.2%
15143.328	2	< 0.1%
15142.464	4	< 0.1%
15141.6	23	0.2%
15140.736	16	0.2%
15139.872	15	0.2%
15139.008	27	0.3%
15138.144	11	0.1%

Ship Date
Real number (ℝ)

Distinct	1334
Distinct (%)	13.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	14623.168

Minimum	13890.528
Maximum	15151.104
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	78.2 KiB

Quantile statistics

Minimum	13890.528
5-th percentile	14011.186
Q1	14326.848
median	14671.584
Q3	14950.656
95-th percentile	15120.864
Maximum	15151.104
Range	1260.576
Interquartile range (IQR)	623.808

Descriptive statistics

Standard deviation	363.2733
Coefficient of variation (CV)	0.024842312
Kurtosis	-1.1532138
Mean	14623.168
Median Absolute Deviation (MAD)	305.856
Skewness	-0.2678001
Sum	1.4614394 × 10⁸
Variance	131967.49
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
14502.24	35	0.4%
15063.84	34	0.3%
15125.184	32	0.3%
15112.224	32	0.3%
15046.56	30	0.3%
15130.368	30	0.3%
15054.336	30	0.3%
14105.664	27	0.3%
15048.288	27	0.3%
15109.632	26	0.3%
Other values (1324)	9691	97.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
13890.528	2	< 0.1%
13891.392	4	< 0.1%
13893.12	7	0.1%
13894.848	3	< 0.1%
13895.712	2	< 0.1%
13896.576	1	< 0.1%
13897.44	8	0.1%
13898.304	1	< 0.1%
13899.168	1	< 0.1%
13900.032	9	0.1%

Value	Count	Frequency (%)
15151.104	2	< 0.1%
15150.24	5	0.1%
15149.376	7	0.1%
15148.512	8	0.1%
15147.648	20	0.2%
15146.784	6	0.1%
15145.92	8	0.1%
15145.056	12	0.1%
15144.192	23	0.2%
15143.328	12	0.1%

Ship Mode
Categorical

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	10.1 KiB

Standard Class	5968
Second Class	1945
First Class	1538
Same Day	543

Length

Max length	14
Median length	14
Mean length	12.823094
Min length	8

Characters and Unicode

Total characters	128154
Distinct characters	18
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Second Class
2nd row	Second Class
3rd row	Second Class
4th row	Standard Class
5th row	Standard Class

Common Values

Value	Count	Frequency (%)
Standard Class	5968	59.7%
Second Class	1945	19.5%
First Class	1538	15.4%
Same Day	543	5.4%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
class	9451	47.3%
standard	5968	29.9%
second	1945	9.7%
first	1538	7.7%
same	543	2.7%
day	543	2.7%

Most occurring characters

Value	Count	Frequency (%)
a	22473	17.5%
s	20440	15.9%
d	13881	10.8%
	9994	7.8%
l	9451	7.4%
C	9451	7.4%
S	8456	6.6%
n	7913	6.2%
r	7506	5.9%
t	7506	5.9%
Other values (8)	11083	8.6%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	98172	76.6%
Uppercase Letter	19988	15.6%
Space Separator	9994	7.8%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	22473	22.9%
s	20440	20.8%
d	13881	14.1%
l	9451	9.6%
n	7913	8.1%
r	7506	7.6%
t	7506	7.6%
e	2488	2.5%
c	1945	2.0%
o	1945	2.0%
Other values (3)	2624	2.7%

Uppercase Letter

Value	Count	Frequency (%)
C	9451	47.3%
S	8456	42.3%
F	1538	7.7%
D	543	2.7%

Space Separator

Value	Count	Frequency (%)
	9994	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	118160	92.2%
Common	9994	7.8%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	22473	19.0%
s	20440	17.3%
d	13881	11.7%
l	9451	8.0%
C	9451	8.0%
S	8456	7.2%
n	7913	6.7%
r	7506	6.4%
t	7506	6.4%
e	2488	2.1%
Other values (7)	8595	7.3%

Common

Value	Count	Frequency (%)
	9994	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	128154	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
a	22473	17.5%
s	20440	15.9%
d	13881	10.8%
	9994	7.8%
l	9451	7.4%
C	9451	7.4%
S	8456	6.6%
n	7913	6.2%
r	7506	5.9%
t	7506	5.9%
Other values (8)	11083	8.6%

Segment
Categorical

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	10.0 KiB

Consumer	5191
Corporate	3020
Home Office	1783

Length

Max length	11
Median length	8
Mean length	8.8374024
Min length	8

Characters and Unicode

Total characters	88321
Distinct characters	17
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Consumer
2nd row	Consumer
3rd row	Corporate
4th row	Consumer
5th row	Consumer

Common Values

Value	Count	Frequency (%)
Consumer	5191	51.9%
Corporate	3020	30.2%
Home Office	1783	17.8%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
consumer	5191	44.1%
corporate	3020	25.6%
home	1783	15.1%
office	1783	15.1%

Most occurring characters

Value	Count	Frequency (%)
o	13014	14.7%
e	11777	13.3%
r	11231	12.7%
C	8211	9.3%
m	6974	7.9%
n	5191	5.9%
s	5191	5.9%
u	5191	5.9%
f	3566	4.0%
t	3020	3.4%
Other values (7)	14955	16.9%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	74761	84.6%
Uppercase Letter	11777	13.3%
Space Separator	1783	2.0%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
o	13014	17.4%
e	11777	15.8%
r	11231	15.0%
m	6974	9.3%
n	5191	6.9%
s	5191	6.9%
u	5191	6.9%
f	3566	4.8%
t	3020	4.0%
p	3020	4.0%
Other values (3)	6586	8.8%

Uppercase Letter

Value	Count	Frequency (%)
C	8211	69.7%
H	1783	15.1%
O	1783	15.1%

Space Separator

Value	Count	Frequency (%)
	1783	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	86538	98.0%
Common	1783	2.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
o	13014	15.0%
e	11777	13.6%
r	11231	13.0%
C	8211	9.5%
m	6974	8.1%
n	5191	6.0%
s	5191	6.0%
u	5191	6.0%
f	3566	4.1%
t	3020	3.5%
Other values (6)	13172	15.2%

Common

Value	Count	Frequency (%)
	1783	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	88321	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
o	13014	14.7%
e	11777	13.3%
r	11231	12.7%
C	8211	9.3%
m	6974	7.9%
n	5191	5.9%
s	5191	5.9%
u	5191	5.9%
f	3566	4.0%
t	3020	3.4%
Other values (7)	14955	16.9%

Region
Categorical

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	10.1 KiB

West	3203
East	2848
Central	2323
South	1620

Length

Max length	7
Median length	4
Mean length	4.8594156
Min length	4

Characters and Unicode

Total characters	48565
Distinct characters	14
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	South
2nd row	South
3rd row	West
4th row	South
5th row	South

Common Values

Value	Count	Frequency (%)
West	3203	32.0%
East	2848	28.5%
Central	2323	23.2%
South	1620	16.2%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
west	3203	32.0%
east	2848	28.5%
central	2323	23.2%
south	1620	16.2%

Most occurring characters

Value	Count	Frequency (%)
t	9994	20.6%
s	6051	12.5%
e	5526	11.4%
a	5171	10.6%
W	3203	6.6%
E	2848	5.9%
C	2323	4.8%
n	2323	4.8%
r	2323	4.8%
l	2323	4.8%
Other values (4)	6480	13.3%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	38571	79.4%
Uppercase Letter	9994	20.6%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
t	9994	25.9%
s	6051	15.7%
e	5526	14.3%
a	5171	13.4%
n	2323	6.0%
r	2323	6.0%
l	2323	6.0%
o	1620	4.2%
u	1620	4.2%
h	1620	4.2%

Uppercase Letter

Value	Count	Frequency (%)
W	3203	32.0%
E	2848	28.5%
C	2323	23.2%
S	1620	16.2%

Most occurring scripts

Value	Count	Frequency (%)
Latin	48565	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
t	9994	20.6%
s	6051	12.5%
e	5526	11.4%
a	5171	10.6%
W	3203	6.6%
E	2848	5.9%
C	2323	4.8%
n	2323	4.8%
r	2323	4.8%
l	2323	4.8%
Other values (4)	6480	13.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	48565	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
t	9994	20.6%
s	6051	12.5%
e	5526	11.4%
a	5171	10.6%
W	3203	6.6%
E	2848	5.9%
C	2323	4.8%
n	2323	4.8%
r	2323	4.8%
l	2323	4.8%
Other values (4)	6480	13.3%

Category
Categorical

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	10.0 KiB

Office Supplies	6026
Furniture	2121
Technology	1847

Length

Max length	15
Median length	15
Mean length	12.802582
Min length	9

Characters and Unicode

Total characters	127949
Distinct characters	20
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Furniture
2nd row	Furniture
3rd row	Office Supplies
4th row	Furniture
5th row	Office Supplies

Common Values

Value	Count	Frequency (%)
Office Supplies	6026	60.3%
Furniture	2121	21.2%
Technology	1847	18.5%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
office	6026	37.6%
supplies	6026	37.6%
furniture	2121	13.2%
technology	1847	11.5%

Most occurring characters

Value	Count	Frequency (%)
e	16020	12.5%
i	14173	11.1%
p	12052	9.4%
f	12052	9.4%
u	10268	8.0%
c	7873	6.2%
l	7873	6.2%
O	6026	4.7%
s	6026	4.7%
S	6026	4.7%
Other values (10)	29560	23.1%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	105903	82.8%
Uppercase Letter	16020	12.5%
Space Separator	6026	4.7%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	16020	15.1%
i	14173	13.4%
p	12052	11.4%
f	12052	11.4%
u	10268	9.7%
c	7873	7.4%
l	7873	7.4%
s	6026	5.7%
r	4242	4.0%
n	3968	3.7%
Other values (5)	11356	10.7%

Uppercase Letter

Value	Count	Frequency (%)
O	6026	37.6%
S	6026	37.6%
F	2121	13.2%
T	1847	11.5%

Space Separator

Value	Count	Frequency (%)
	6026	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	121923	95.3%
Common	6026	4.7%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	16020	13.1%
i	14173	11.6%
p	12052	9.9%
f	12052	9.9%
u	10268	8.4%
c	7873	6.5%
l	7873	6.5%
O	6026	4.9%
s	6026	4.9%
S	6026	4.9%
Other values (9)	23534	19.3%

Common

Value	Count	Frequency (%)
	6026	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	127949	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	16020	12.5%
i	14173	11.1%
p	12052	9.4%
f	12052	9.4%
u	10268	8.0%
c	7873	6.2%
l	7873	6.2%
O	6026	4.7%
s	6026	4.7%
S	6026	4.7%
Other values (10)	29560	23.1%

Sub-Category
Categorical

Distinct	17
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Memory size	10.6 KiB

Binders	1523
Paper	1370
Furnishings	957
Phones	889
Storage	846
Other values (12)	4409

Length

Max length	11
Median length	9
Mean length	7.191715
Min length	3

Characters and Unicode

Total characters	71874
Distinct characters	28
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Bookcases
2nd row	Chairs
3rd row	Labels
4th row	Tables
5th row	Storage

Common Values

Value	Count	Frequency (%)
Binders	1523	15.2%
Paper	1370	13.7%
Furnishings	957	9.6%
Phones	889	8.9%
Storage	846	8.5%
Art	796	8.0%
Accessories	775	7.8%
Chairs	617	6.2%
Appliances	466	4.7%
Labels	364	3.6%
Other values (7)	1391	13.9%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
binders	1523	15.2%
paper	1370	13.7%
furnishings	957	9.6%
phones	889	8.9%
storage	846	8.5%
art	796	8.0%
accessories	775	7.8%
chairs	617	6.2%
appliances	466	4.7%
labels	364	3.6%
Other values (7)	1391	13.9%

Most occurring characters

Value	Count	Frequency (%)
s	9934	13.8%
e	8870	12.3%
r	7169	10.0%
i	5668	7.9%
n	5378	7.5%
a	4542	6.3%
o	3288	4.6%
p	3004	4.2%
h	2578	3.6%
c	2359	3.3%
Other values (18)	19084	26.6%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	61880	86.1%
Uppercase Letter	9994	13.9%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
s	9934	16.1%
e	8870	14.3%
r	7169	11.6%
i	5668	9.2%
n	5378	8.7%
a	4542	7.3%
o	3288	5.3%
p	3004	4.9%
h	2578	4.2%
c	2359	3.8%
Other values (8)	9090	14.7%

Uppercase Letter

Value	Count	Frequency (%)
P	2259	22.6%
A	2037	20.4%
B	1751	17.5%
F	1174	11.7%
S	1036	10.4%
C	685	6.9%
L	364	3.6%
T	319	3.2%
E	254	2.5%
M	115	1.2%

Most occurring scripts

Value	Count	Frequency (%)
Latin	71874	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
s	9934	13.8%
e	8870	12.3%
r	7169	10.0%
i	5668	7.9%
n	5378	7.5%
a	4542	6.3%
o	3288	4.6%
p	3004	4.2%
h	2578	3.6%
c	2359	3.3%
Other values (18)	19084	26.6%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	71874	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
s	9934	13.8%
e	8870	12.3%
r	7169	10.0%
i	5668	7.9%
n	5378	7.5%
a	4542	6.3%
o	3288	4.6%
p	3004	4.2%
h	2578	3.6%
c	2359	3.3%
Other values (18)	19084	26.6%

Sales
Real number (ℝ)

Distinct	5825
Distinct (%)	58.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	229.858

Minimum	0.444
Maximum	22638.48
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	78.2 KiB

Quantile statistics

Minimum	0.444
5-th percentile	4.98
Q1	17.28
median	54.49
Q3	209.94
95-th percentile	956.98425
Maximum	22638.48
Range	22638.036
Interquartile range (IQR)	192.66

Descriptive statistics

Standard deviation	623.2451
Coefficient of variation (CV)	2.7114353
Kurtosis	305.31175
Mean	229.858
Median Absolute Deviation (MAD)	45.406
Skewness	12.972752
Sum	2297200.9
Variance	388434.46
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
12.96	56	0.6%
19.44	39	0.4%
15.552	39	0.4%
25.92	36	0.4%
10.368	36	0.4%
32.4	28	0.3%
17.94	21	0.2%
6.48	21	0.2%
20.736	19	0.2%
14.94	17	0.2%
Other values (5815)	9682	96.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.444	1	< 0.1%
0.556	1	< 0.1%
0.836	1	< 0.1%
0.852	1	< 0.1%
0.876	1	< 0.1%
0.898	1	< 0.1%
0.984	1	< 0.1%
0.99	1	< 0.1%
1.044	1	< 0.1%
1.08	3	< 0.1%

Value	Count	Frequency (%)
22638.48	1	< 0.1%
17499.95	1	< 0.1%
13999.96	1	< 0.1%
11199.968	1	< 0.1%
10499.97	1	< 0.1%
9892.74	1	< 0.1%
9449.95	1	< 0.1%
9099.93	1	< 0.1%
8749.95	1	< 0.1%
8399.976	1	< 0.1%

Quantity
Real number (ℝ)

Distinct	14
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3.7895737

Minimum	1
Maximum	14
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	78.2 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	2
median	3
Q3	5
95-th percentile	8
Maximum	14
Range	13
Interquartile range (IQR)	3

Descriptive statistics

Standard deviation	2.2251097
Coefficient of variation (CV)	0.58716622
Kurtosis	1.9918894
Mean	3.7895737
Median Absolute Deviation (MAD)	1
Skewness	1.2785448
Sum	37873
Variance	4.9511131
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=14)

Value	Count	Frequency (%)
3	2409	24.1%
2	2402	24.0%
5	1230	12.3%
4	1191	11.9%
1	899	9.0%
7	606	6.1%
6	572	5.7%
9	258	2.6%
8	257	2.6%
10	57	0.6%
Other values (4)	113	1.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	899	9.0%
2	2402	24.0%
3	2409	24.1%
4	1191	11.9%
5	1230	12.3%
6	572	5.7%
7	606	6.1%
8	257	2.6%
9	258	2.6%
10	57	0.6%

Value	Count	Frequency (%)
14	29	0.3%
13	27	0.3%
12	23	0.2%
11	34	0.3%
10	57	0.6%
9	258	2.6%
8	257	2.6%
7	606	6.1%
6	572	5.7%
5	1230	12.3%

Discount
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	12
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.15620272

Minimum	0
Maximum	0.8
Zeros	4798
Zeros (%)	48.0%
Negative	0
Negative (%)	0.0%
Memory size	78.2 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0.2
Q3	0.2
95-th percentile	0.7
Maximum	0.8
Range	0.8
Interquartile range (IQR)	0.2

Descriptive statistics

Standard deviation	0.20645197
Coefficient of variation (CV)	1.3216925
Kurtosis	2.4095461
Mean	0.15620272
Median Absolute Deviation (MAD)	0.2
Skewness	1.6842947
Sum	1561.09
Variance	0.042622415
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=12)

Value	Count	Frequency (%)
0	4798	48.0%
0.2	3657	36.6%
0.7	418	4.2%
0.8	300	3.0%
0.3	227	2.3%
0.4	206	2.1%
0.6	138	1.4%
0.1	94	0.9%
0.5	66	0.7%
0.15	52	0.5%
Other values (2)	38	0.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	4798	48.0%
0.1	94	0.9%
0.15	52	0.5%
0.2	3657	36.6%
0.3	227	2.3%
0.32	27	0.3%
0.4	206	2.1%
0.45	11	0.1%
0.5	66	0.7%
0.6	138	1.4%

Value	Count	Frequency (%)
0.8	300	3.0%
0.7	418	4.2%
0.6	138	1.4%
0.5	66	0.7%
0.45	11	0.1%
0.4	206	2.1%
0.32	27	0.3%
0.3	227	2.3%
0.2	3657	36.6%
0.15	52	0.5%

Profit
Real number (ℝ)

Distinct	7287
Distinct (%)	72.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	28.656896

Minimum	-6599.978
Maximum	8399.976
Zeros	65
Zeros (%)	0.7%
Negative	1871
Negative (%)	18.7%
Memory size	78.2 KiB

Quantile statistics

Minimum	-6599.978
5-th percentile	-53.03092
Q1	1.72875
median	8.6665
Q3	29.364
95-th percentile	168.4704
Maximum	8399.976
Range	14999.954
Interquartile range (IQR)	27.63525

Descriptive statistics

Standard deviation	234.26011
Coefficient of variation (CV)	8.1746504
Kurtosis	397.18851
Mean	28.656896
Median Absolute Deviation (MAD)	10.77855
Skewness	7.5614316
Sum	286397.02
Variance	54877.798
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	65	0.7%
6.2208	43	0.4%
9.3312	38	0.4%
5.4432	32	0.3%
3.6288	32	0.3%
15.552	26	0.3%
12.4416	21	0.2%
7.2576	19	0.2%
3.1104	18	0.2%
9.072	11	0.1%
Other values (7277)	9689	96.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-6599.978	1	< 0.1%
-3839.9904	1	< 0.1%
-3701.8928	1	< 0.1%
-3399.98	1	< 0.1%
-2929.4845	1	< 0.1%
-2639.9912	1	< 0.1%
-2287.782	1	< 0.1%
-1862.3124	1	< 0.1%
-1850.9464	1	< 0.1%
-1811.0784	1	< 0.1%

Value	Count	Frequency (%)
8399.976	1	< 0.1%
6719.9808	1	< 0.1%
5039.9856	1	< 0.1%
4946.37	1	< 0.1%
4630.4755	1	< 0.1%
3919.9888	1	< 0.1%
3177.475	1	< 0.1%
2799.984	1	< 0.1%
2591.9568	1	< 0.1%
2504.2216	1	< 0.1%

Customer ID_id
Real number (ℝ)

Distinct	793
Distinct (%)	7.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	400.46038

Minimum	0
Maximum	792
Zeros	11
Zeros (%)	0.1%
Negative	0
Negative (%)	0.0%
Memory size	78.2 KiB

Quantile statistics

Minimum	0
5-th percentile	39
Q1	205.25
median	405.5
Q3	602
95-th percentile	753
Maximum	792
Range	792
Interquartile range (IQR)	396.75

Descriptive statistics

Standard deviation	228.58558
Coefficient of variation (CV)	0.57080698
Kurtosis	-1.1915803
Mean	400.46038
Median Absolute Deviation (MAD)	197.5
Skewness	-0.025462504
Sum	4002201
Variance	52251.366
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
787	37	0.4%
387	34	0.3%
482	34	0.3%
606	34	0.3%
147	32	0.3%
720	32	0.3%
349	32	0.3%
257	32	0.3%
791	31	0.3%
275	31	0.3%
Other values (783)	9665	96.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	11	0.1%
1	15	0.2%
2	12	0.1%
3	18	0.2%
4	6	0.1%
5	18	0.2%
6	20	0.2%
7	12	0.1%
8	14	0.1%
9	14	0.1%

Value	Count	Frequency (%)
792	9	0.1%
791	31	0.3%
790	12	0.1%
789	8	0.1%
788	28	0.3%
787	37	0.4%
786	18	0.2%
785	9	0.1%
784	8	0.1%
783	14	0.1%

Product ID_id
Real number (ℝ)

Distinct	1862
Distinct (%)	18.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	898.47238

Minimum	0
Maximum	1861
Zeros	1
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	78.2 KiB

Quantile statistics

Minimum	0
5-th percentile	90
Q1	453
median	863
Q3	1347
95-th percentile	1758.35
Maximum	1861
Range	1861
Interquartile range (IQR)	894

Descriptive statistics

Standard deviation	526.70844
Coefficient of variation (CV)	0.58622664
Kurtosis	-1.1364991
Mean	898.47238
Median Absolute Deviation (MAD)	453
Skewness	0.056258336
Sum	8979333
Variance	277421.79
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1144	19	0.2%
1569	18	0.2%
295	16	0.2%
65	15	0.2%
1566	15	0.2%
93	15	0.2%
1517	15	0.2%
831	14	0.1%
694	14	0.1%
97	14	0.1%
Other values (1852)	9839	98.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1	< 0.1%
1	3	< 0.1%
2	5	0.1%
3	6	0.1%
4	2	< 0.1%
5	5	0.1%
6	10	0.1%
7	5	0.1%
8	1	< 0.1%
9	3	< 0.1%

Value	Count	Frequency (%)
1861	9	0.1%
1860	2	< 0.1%
1859	3	< 0.1%
1858	5	0.1%
1857	3	< 0.1%
1856	7	0.1%
1855	7	0.1%
1854	5	0.1%
1853	1	< 0.1%
1852	4	< 0.1%

Auto

Heatmap
Table

	Order Date	Ship Date	Sales	Quantity	Discount	Profit	Customer ID_id	Product ID_id	Ship Mode	Segment	Region	Category	Sub-Category
Order Date	1.000	1.000	-0.002	-0.000	-0.004	0.001	-0.038	0.001	0.039	0.036	0.060	0.000	0.000
Ship Date	1.000	1.000	-0.002	-0.000	-0.004	0.001	-0.038	0.001	0.041	0.039	0.058	0.000	0.000
Sales	-0.002	-0.002	1.000	0.327	-0.057	0.518	0.007	0.060	0.000	0.002	0.000	0.072	0.142
Quantity	-0.000	-0.000	0.327	1.000	-0.001	0.234	0.019	-0.010	0.000	0.012	0.000	0.000	0.000
Discount	-0.004	-0.004	-0.057	-0.001	1.000	-0.543	0.017	-0.116	0.027	0.005	0.294	0.377	0.353
Profit	0.001	0.001	0.518	0.234	-0.543	1.000	-0.005	0.177	0.005	0.000	0.021	0.056	0.130
Customer ID_id	-0.038	-0.038	0.007	0.019	0.017	-0.005	1.000	0.005	0.030	0.134	0.045	0.000	0.000
Product ID_id	0.001	0.001	0.060	-0.010	-0.116	0.177	0.005	1.000	0.000	0.009	0.000	0.975	0.841
Ship Mode	0.039	0.041	0.000	0.000	0.027	0.005	0.030	0.000	1.000	0.033	0.022	0.000	0.007
Segment	0.036	0.039	0.002	0.012	0.005	0.000	0.134	0.009	0.033	1.000	0.000	0.000	0.000
Region	0.060	0.058	0.000	0.000	0.294	0.021	0.045	0.000	0.022	0.000	1.000	0.000	0.000
Category	0.000	0.000	0.072	0.000	0.377	0.056	0.000	0.975	0.000	0.000	0.000	1.000	0.999
Sub-Category	0.000	0.000	0.142	0.000	0.353	0.130	0.000	0.841	0.007	0.000	0.000	0.999	1.000

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows
Last rows

	Order Date	Ship Date	Ship Mode	Segment	Region	Category	Sub-Category	Sales	Quantity	Discount	Profit	Customer ID_id	Product ID_id
0	14785.632	14788.224	Second Class	Consumer	South	Furniture	Bookcases	261.9600	2	0.00	41.9136	143	12
1	14785.632	14788.224	Second Class	Consumer	South	Furniture	Chairs	731.9400	3	0.00	219.5820	143	55
2	14656.896	14660.352	Second Class	Corporate	West	Office Supplies	Labels	14.6200	2	0.00	6.8714	237	946
3	14445.216	14451.264	Standard Class	Consumer	South	Furniture	Tables	957.5775	5	0.45	-383.0310	705	319
4	14445.216	14451.264	Standard Class	Consumer	South	Office Supplies	Storage	22.3680	2	0.20	2.5164	705	1316
5	14022.720	14027.040	Standard Class	Consumer	West	Furniture	Furnishings	48.8600	7	0.00	14.1694	88	185
6	14022.720	14027.040	Standard Class	Consumer	West	Office Supplies	Art	7.2800	4	0.00	1.9656	88	562
7	14022.720	14027.040	Standard Class	Consumer	West	Technology	Phones	907.1520	6	0.20	90.7152	88	1761
8	14022.720	14027.040	Standard Class	Consumer	West	Office Supplies	Binders	18.5040	3	0.20	5.7825	88	794
9	14022.720	14027.040	Standard Class	Consumer	West	Office Supplies	Appliances	114.9000	5	0.00	34.4700	88	437

	Order Date	Ship Date	Ship Mode	Segment	Region	Category	Sub-Category	Sales	Quantity	Discount	Profit	Customer ID_id	Product ID_id
9984	14318.208	14323.392	Standard Class	Consumer	East	Office Supplies	Labels	31.500	10	0.0	15.1200	238	995
9985	14318.208	14323.392	Standard Class	Consumer	East	Office Supplies	Supplies	55.600	4	0.0	16.1240	238	1425
9986	14751.072	14754.528	Standard Class	Consumer	West	Technology	Accessories	36.240	1	0.0	15.2208	520	1558
9987	15108.768	15112.224	Standard Class	Corporate	South	Technology	Accessories	79.990	1	0.0	28.7964	617	1498
9988	15108.768	15112.224	Standard Class	Corporate	South	Technology	Phones	206.100	5	0.0	55.6470	617	1826
9989	13902.624	13904.352	Second Class	Consumer	South	Furniture	Furnishings	25.248	3	0.2	4.1028	737	200
9990	14880.672	14884.992	Standard Class	Consumer	West	Furniture	Furnishings	91.960	2	0.0	15.6332	190	164
9991	14880.672	14884.992	Standard Class	Consumer	West	Technology	Phones	258.576	2	0.2	19.3932	190	1816
9992	14880.672	14884.992	Standard Class	Consumer	West	Office Supplies	Paper	29.600	4	0.0	13.3200	190	1247
9993	14938.560	14942.880	Second Class	Consumer	West	Office Supplies	Appliances	243.160	2	0.0	72.9480	130	433

Most frequently occurring

	Order Date	Ship Date	Ship Mode	Segment	Region	Category	Sub-Category	Sales	Quantity	Discount	Profit	Customer ID_id	Product ID_id	# duplicates
2300	13982.112	13985.568	Standard Class	Home Office	East	Furniture	Chairs	281.372	2	0.3	-12.0588	449	99	2
0	13982.112	13985.568	First Class	Consumer	Central	Furniture	Accessories	281.372	2	0.3	-12.0588	449	99	0
1	13982.112	13985.568	First Class	Consumer	Central	Furniture	Appliances	281.372	2	0.3	-12.0588	449	99	0
2	13982.112	13985.568	First Class	Consumer	Central	Furniture	Art	281.372	2	0.3	-12.0588	449	99	0
3	13982.112	13985.568	First Class	Consumer	Central	Furniture	Binders	281.372	2	0.3	-12.0588	449	99	0
4	13982.112	13985.568	First Class	Consumer	Central	Furniture	Bookcases	281.372	2	0.3	-12.0588	449	99	0
5	13982.112	13985.568	First Class	Consumer	Central	Furniture	Chairs	281.372	2	0.3	-12.0588	449	99	0
6	13982.112	13985.568	First Class	Consumer	Central	Furniture	Copiers	281.372	2	0.3	-12.0588	449	99	0
7	13982.112	13985.568	First Class	Consumer	Central	Furniture	Envelopes	281.372	2	0.3	-12.0588	449	99	0
8	13982.112	13985.568	First Class	Consumer	Central	Furniture	Fasteners	281.372	2	0.3	-12.0588	449	99	0

Overview

Variables

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Space Separator

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Space Separator

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Most occurring scripts

Most frequent character per script

Latin

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Space Separator

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Most occurring scripts

Most frequent character per script

Latin

Most occurring blocks

Most frequent character per block

ASCII

Interactions

Correlations

Missing values